1767. Find the Subtasks That Did Not Execute.sql

WITH RECURSIVE all_subtasks AS (
SELECT task_id,subtasks_count,1AS subtask_id
FROM tasks_1767
UNION ALL
SELECT task_id,subtasks_count,subtask_id+1AS subtask_id
FROM all_subtasks
WHERE subtask_id<subtasks_count
)
SELECTa.task_id,a.subtask_id
FROM all_subtasks a
LEFT JOIN executed_1767 e ONa.task_id=e.task_idANDa.subtask_id=e.subtask_id
WHEREe.task_id IS NULL
ORDER BY1,2;